﻿

-- 取得班组及其下属人员信息
CREATE procedure [dbo].[GroupRyInfo_GetTreeAll]
as
select bzid,bzfid,bzmc from dbo.Banz_Info
select sfzh,bzid,xm+'('+sfzh+')' xm,xm xmdis,isnull(bzmc,'未知') bzmc from vRyBzInfo